CREATE TABLE [dbo].[TDBANC_FINA]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_PROV] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST_LINE_CCRE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TDBANC_FI__ST_LI__0AF29B96] DEFAULT ('N'),
[CO_MONE_CRED] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IM_LINE_CRED] [numeric] (16, 4) NULL CONSTRAINT [DF__TDBANC_FI__IM_LI__0CDAE408] DEFAULT ((0)),
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TDBANC_FI__CO_US__0DCF0841] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TDBANC_FI__FE_US__0EC32C7A] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TDBANC_FI__CO_US__0FB750B3] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TDBANC_FI__FE_US__10AB74EC] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDBANC_FINA] WITH NOCHECK ADD CONSTRAINT [CK__TDBANC_FI__ST_LI__0BE6BFCF] CHECK NOT FOR REPLICATION (([ST_LINE_CCRE]='N' OR [ST_LINE_CCRE]='S'))
GO
ALTER TABLE [dbo].[TDBANC_FINA] ADD CONSTRAINT [PK__TDBANC_F__CDFDE18D791ECF75] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_BANC]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDBANC_FINA] ADD CONSTRAINT [FK__TDBANC_FI__CO_EM__2AA11C70] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
